SELECT *, CASE WHEN `name` LIKE "manhattan%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "manhattan" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "manhattan" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "manhattan" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("manhattan") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$60,000,00036 E 63rd St Unit TownhouseManhattan NY 10065View Listing
$39,995,000145 Reade StManhattan NY 10013View Listing
$29,950,000730 Park Avenue Ave Phs 19 & 20CManhattan NY 10021View Listing
$27,995,0008 E 63rd StManhattan NY 10065View Listing
$27,400,000927 Fifth Ave Unit 9THFLRManhattan NY 10021View Listing
$25,000,00011 Hubert StManhattan NY 10013View Listing
$25,000,0007 E 88th St Unit TownhouseManhattan NY 10128View Listing
$24,500,000452 Greenwich StManhattan NY 10013View Listing
$23,500,00010 E 75th St Unit TownhouseManhattan NY 10021View Listing
$23,000,000334 W 20th St Unit TownhouseManhattan NY 10011View Listing
$19,995,000109 Waverly PlManhattan NY 10011View Listing
$19,950,000115 Central Park W Ph 18EFManhattan NY 10023View Listing
$18,000,000720 Park Avenue Ave Ph 13AManhattan NY 10021View Listing
$17,990,00050 Central Park W Units 8A & 9AManhattan NY 10023View Listing
$17,950,000211 Central Park W Unit 14DManhattan NY 10024View Listing
$17,750,000944 5th Ave Unit 6Manhattan NY 10021View Listing
$16,200,00057 W 9th St Unit TownhouseManhattan NY 10011View Listing
$15,999,999280 W 11th St Unit TownhouseManhattan NY 10014View Listing
$15,990,000175-177 E 78th StManhattan NY 10075View Listing
$15,500,00050 W 12th St Unit TownhouseManhattan NY 10011View Listing
$15,000,000820 Fifth Ave Unit MaisonetteManhattan NY 10065View Listing
$14,995,000184 E 75th StManhattan NY 10021View Listing
$14,995,00050 W 86th St Unit TownhouseManhattan NY 10024View Listing
$14,900,000765 Park Avenue Ave Unit 7BManhattan NY 10021View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 2:58:53 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah